![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
These qualities went into the first benchmark developed by the TPC and are still present in all the benchmarks developed today. In the years since the TPC was originally founded, it has grown from the original 8 members to over 40 of the leading computer industry companies. As of January 1, 1996, the TPC membership consists of the following companies:
The TPC is made up of the general membership, in which each member company has one vote. From the general membership, a steering committee and Technical Advisory Board are elected. The steering committee is responsible for setting the overall direction of the council and providing recommendations to the council. It is also charged with the administrative and support activities of the council. The Technical Advisory Board (TAB) investigates issues involving compliance to TPC specifications and makes recommendations to the council on these matters. The TAB is also responsible for recommending changes to the benchmark specifications for clarity. Any change in a specification or compliance issue decided by the TAB must be brought to the general council for decision. Every issue in the TPC requires a 2/3 majority for passage. The steering committee and TAB are merely filters; all significant decisions are made by the general council. The TPC has gone from the original Credit/Debit benchmark to seven benchmarks (by mid-1996). These benchmarks include Decision Support, Client/Server, and Enterprise benchmarks. Each of these benchmark specifications is discussed in this chapter. TPC Rules and RegulationsTo publish a TPC benchmark result, the sponsoring company is required to follow a set of rules and regulations. These rules are designed to provide a fair playing field for all participants. Here are some of the significant rules:
These rules have been approved by the council and must be followed by all members. If these rules are violated, the council has steps it can take. It is very rare that any of the rules are violatedand then usually by mistake. ACID Properties The ACID (Atomicity, Consistency, Isolation, Durability) properties are designed to show that the system operates in a manner consistent with systems deployed in user installations. ACID properties are the main regulating factor that keeps benchmarks from being published in a mode inconsistent with typical operation. Consider a case in which the system might run faster if logging were disabled. Although the performance increases, the test is inconsistent with typical operation because disabling logging prohibits any recovery in the event of a system failure. The ACID properties are as follows:
These properties guarantee the integrity of the system and add credibility to the benchmark results. Although these tests are quite time consuming, they are required for a certified result. Requirements like these give a lot of credibility to the TPC and to the vendors that run the tests. To pass these ACID tests, the database platform must prove it is a stable, robust system capable of handling your business.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |